package vip.xiaonuo.smzq.modular.psba.mapper;

import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.psba.entity.PsbaGtJbqk;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

/**
 * 评审备案-非压覆基本情况 Mapper
 *
 * @author Kevin
 * @since 2024-05-15
 */
@Mapper
public interface PsbaGtJbqkMapper extends BaseMapper<PsbaGtJbqk> {
   @Select("SELECT LPAD(CAST(MAX(CAST(SUBSTRING(psbabh, LENGTH(psbabh) - 2, 3) AS INT)) + 1 AS TEXT), 3, '0') AS sxh  FROM psba_sqjl_jbqk where psbabh like  '%' || #{nd} || '%'")
    String getSxh(String nd);
}
